You are here: 1. Distribution System > 1.10. MAINTENANCE Menu: System Maintenance > 1.10.2. Maintenance - Edit Company > 1.10.2.15. Edit Company - Edit - General Ledger Config > Edit - General Ledger Config - General Ledger Setup
Edit - General Ledger Config - General Ledger Setup

Use this option to enter general configuration details for MGL, such as current periods, account numbering conventions, and to enable T accounts.

  1. Select a company to edit.

Refer to "Selecting a Company to Edit"

  1. Select EDIT | GENERAL LEDGER CONFIG | GENERAL LEDGER SETUP.

Micronet displays the General Ledger Setup screen.

  1. Complete the following fields:

 

Field

Value

 

Current Distribution Period

Micronet displays the period MDS is set to. This is updated each time End of Month is run in MDS.

 

Current Creditors Period

Micronet displays the period MCL is set to. This is updated each time End of Month is run in MCL.

 

Current GL Period

Micronet displays the period MGL is set to. This is updated each time End of Month is run in MGL.

 

 

Warning

Never manually change the period for MDS, MCL or MGL.

 

 

Technical Tip

When users are entering transactions into Micronet, it automatically picks up the current period setting from these fields. However, the default can always be overridden if transactions need to be entered into alternative periods.

Micronet also automatically picks up the current period setting from these fields for reporting. Reports can be printed for any of the periods available in the General Ledger, allowing the default period to be overridden.

 

 

Digits in Department

This field is only relevant if you intend to setup departments, divisions or cost centres in your General Ledger and report on them individually. In such cases, a numeric prefix is attached to the GL accounts setup in the Chart of Accounts.

Enter the number of digits in the account prefix. For example, if you set this field to 2, then each GL account appears with a two digit prefix, e.g.:

  • 20-41230: Sales
  • 30-41230: Sales
  • 20-51000: Cost of Sales
  • 30-51000: Cost of Sales

Leave this option set to zero if you are not using departments or if you will be using T accounts instead. When this option is set to zero, departments are disabled and the FILE | DEPARTMENT menu option in MGL is greyed.

 

Digits in Account

Enter the number of digits in each GL account within your Chart of Accounts. For example, if you have a five digit account numbering sequence (such as 41230 = Sales), you would enter 5. This option can be set from 1 through to 999999.

 

Digits in Subaccount

Sub-accounts are used to break down expense classifications (GL accounts). This field sets the number of digits that appear after a GL account if sub-accounting is to be used. For example, say you want to divide motor vehicle expenses by vehicle:

  • 71400: Motor Vehicle Expenses (GL Account)
  • 71400-10: Utility (Sub-Account)
  • 71400-20: Delivery Truck (Sub-Account)
  • 71400-99: Total Motor Vehicle Expenses (Sub-Account)

In this example, the Digits in Department would be set to 0, Digits in Account would be set to 5, and Digits in Subaccount would be set to 2.

Here is another example where Digits in Department is set to 0, Digits in Account is set to 3, and Digits in Subaccount is set to 2:

GL Account Number

Sub-account Number

 

835

00

MV Exps - Petrol & Oil

835

01

ABC-123

835

02

XYX-999

835

03

DEF-789

835

04

HIJ-678

 

Separator in GL Accounts

If you are using departments or sub-accounts, you should leave this as the default hyphen (-). Otherwise, leave this field blank.

In the example of motor vehicles above, the - represents the dash that appears between the GL account number and the 2 digit sub-account number.

 

Last Audit Page Number

MGL prints audit reports detailing transactions entered to the ledgers. These reports print as sequential page numbers that can be filed numerically.

This field defaults to zero at initial setup. Therefore, the first audit report page number prints as Page 1.

 

Enable T Accounts

If you want to enable T accounts, select Yes. Otherwise select No.

For more information about T Accounts, refer to "T Accounts".

 

Default to Printing Cheques

Select whether cheques are to be printed automatically or produced manually. Options are:

  • No Cheque – cheques will be manually written and posted into MGL
  • Yes Batch – cheque details will be written to a batch which can be printed at a later stage
  • Print Now – cheques will be printed on completion of entry
  • Record Details, Don’t Print -
 

Use Templates

Select Yes if you are going to setup your Chart of Accounts as a template in MGL, or No if you are not. You should set this field to Yes if you are setting up departments, divisions or cost centres in MGL. You should set it to No if you are setting up T accounts or if you are not setting up departments, divisions or cost centres.

For more information about setting up templates, refer to "File - Template".

 

Use Control Totals

Select Yes if you want control totals displayed to users during batch transaction entry, or No if you don't. If you select No, the Control Amount field on the batch entry screen is greyed out.

All transactions entered to the Micronet General Ledger are entered in batches rather than as individual transactions. As each transaction is entered to the batch, Micronet calculates a running total (value) for the transactions entered.

A control total is a predetermined amount. That is, you are advising Micronet in advance what the batch total is. When a user has finished entering transactions to a batch and chooses to post the batch to the ledgers, Micronet advises them whether the control total entered and the actual batch total agree.

If the two amounts do not agree, Micronet still allows users to post the batch. The control total has no bearing on the ledger balances. Micronet always posts the actual batch total to the ledger. The control total is simply a batch posting reconciliation tool for the user.

  1. Select the Ok button.

Micronet redisplays the Change Existing Company screen.

  1. Select FILE | SAVE to save your changes.
  2. To see your changes take effect, you need to log back in to Micronet.

Refer to "Logging in With Updated Configuration (Method 1)" or "Logging In With Updated Configuration (Method 2)".